﻿/*
Created: 14/10/2014
Modified: 14/10/2014
Project: MD_Sistema_Ventas
Model: Modelo_Datos
Database: MS SQL Server 2012
*/


-- Create tables section -------------------------------------------------

-- Table Provincia

CREATE TABLE [Provincia]
(
 [id_provincia] Int IDENTITY NOT NULL,
 [descripcion] Varchar(50) NOT NULL
)
go

-- Add keys for table Provincia

ALTER TABLE [Provincia] ADD CONSTRAINT [Key2] PRIMARY KEY ([id_provincia])
go

ALTER TABLE [Provincia] ADD CONSTRAINT [descripcion] UNIQUE CLUSTERED ([descripcion])
go



